<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
  <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />

  <title>e网批发管理后台</title>
  <?php include("common/conn.php"); if($_SESSION['userid']==""){echo "<script>window.location.href='login.php';</script>";} 


  ?>
  <script type="text/javascript" src="js/jquery.min.js"></script>
  <link href="css/styles.css" rel="stylesheet" type="text/css" />
  <link href="css/style2.css" rel="stylesheet" type="text/css" />

  <script type="text/JavaScript">
    <!--
function MM_jumpMenu(targ,selObj,restore){ //v3.0
  eval(targ+".location='"+selObj.options[selObj.selectedIndex].value+"'");
  if (restore) selObj.selectedIndex=0;
}
//-->
</script>
</head>

<body>

  <!--header-->
  <?php include("common/header.php");?>
  <!--header end-->


<!-- 
    <td scope="col">
      <?php
      switch ($sdg30[type]) {
        case 0:
          echo "图文详情广告";
          break;
        
        case 1:
          echo "商店分类广告";
          break;

        case 2:
          echo "商家广告";
          break;
      }
      ?>
    </td>

 -->



  <!-- staqrt subnav -->
  <div id="sub_nav">

    <div id="subnav_wrap" class="container_12">

      <!-- start sub nav list -->
    </div>
<br/><br/><br/>


  </div>
  <div class="container_12">
    <!-- <input type="button" class="submit" value="新增热词" onclick="add();"> -->
  </div>
  <!-- end sub_nav -->
  <div class="container_12" style="background: #fff; border:0px; position:relative">

  </div>
    <form action="?del=ok" method="post">
      <div class="container_12">

        <table width="100%" border="0" cellpadding="0" cellspacing="0">
          <tr>
            <th width="5%" scope="col">
              <input type="checkbox" name="checkbox" id="checkbox" class="checkall" /><label for="checkbox"></label></th>
              <th width="13%" scope="col">手机号码/厂商代码</th>
              <th width="13%" scope="col">邀请人</th>
              <th width="18%" scope="col">角色</th>
              <th width="13%" scope="col">邀请人数量</th>
              <th width="13%" scope="col">操作</th>
            </tr> 
            
<?php 
mysql_query('SET NAMES UTF8');
$ren       = "1";
$sex       = "0";
$perNumber = 20; //每页显示的记录数
$page      = $_GET['page']; //获得当前的页面值
$count     = mysql_query("select count(*) from yaoqing");
$i         = 0;

//获得记录总数
$rs=mysql_fetch_array($count);
$totalNumber=$rs[0];
$totalPage=ceil($totalNumber/$perNumber); //计算出总页数

if (!isset($page)) {
  $page=1;
} //如果没有值,则赋值1
$startCount=($page-1)*$perNumber; //分页开始,根据此方法计算出开始的
$user_sql = mysql_query("SELECT DISTINCT a.userid, b.niname, a.role ,b.phone ,COUNT(*) AS num FROM yaoqing AS a LEFT JOIN USER AS b ON a.`userid` = b.`userid` WHERE a.role = '商户' GROUP BY a.userid");
while ($user = mysql_fetch_assoc($user_sql)) {
    $data[$i]['userid']  =   $user['userid'];
    $data[$i]['phone']   =   $user['phone'];
    $data[$i]['niname']  =   $user['niname'];
    $data[$i]['role']    =   $user['role']; 
    $data[$i]['num']     =   $user['num'];
    $i++;
}

$shop_sql = mysql_query("SELECT DISTINCT a.userid, b.name, a.role ,b.phone , b.shop_daima ,COUNT(*) AS num FROM yaoqing AS a LEFT JOIN shop AS b ON a.`userid` = b.`shopid` WHERE a.role = '厂商' GROUP BY a.userid");
while ($shop = mysql_fetch_assoc($shop_sql)) {
  $data[$i]['userid']       =   $shop['userid'];
  if($shop['phone'] == '') {
    $data[$i]['phone']      =   $shop['shop_daima'];
  } else {
    $data[$i]['phone']      =   $shop['phone'] . '/' . $shop['shop_daima'];
  }
  $data[$i]['niname']       =   $shop['name'];
  $data[$i]['role']         =   $shop['role'];
  $data[$i]['num']          =   $shop['num'];
  $i++;
}
foreach($data as $key => $value) {

?>

  <tr>
    <td scope="col">
        <input type="checkbox" name="checkbox[]" id="checkbox"  value="<?php echo $sdg30[id];?>"/>
    </td>
    <td scope="col">
        <?php echo $value['phone'];?>
    </td>
    <td scope="col">
        <?php echo $value['niname'];?>
    </td>
    <td scope="col">
        <?php echo $value['role'];?>
    </td>
    <td scope="col">
        <?php echo $value['num'];?>
    </td>
    <td scope="col"><a href="yaoqingDetail.php?userid=<?php echo $value['userid'];?>" >查看被邀请人</a></td>
  </tr>
<?php } ?>
</table>
<div class="grid_12">

  <!-- <div class="clearfix"><input name="" type="submit" value="删除选中" class="submit"/></div> -->

  <ul id="pagination">



    <?php  

    if ($page > 1) { //上一页 ?>
    <li><a     href="?page=1&keywords=<?php echo $_REQUEST[keywords]; ?>">首页</a></li>
    <li><a     href="?page=<?php echo ($page-1); ?>&keywords=<?php echo $_REQUEST[keywords]; ?>">上一页</a></li>
    <?php }

    ?>

    <li class="active"><?php echo $page;?></li>

    <?php



    if ($_GET[page]!=$totalPage) { //下一页 ?>
    <li><a href="?page=<?php echo ($page+1); ?>&keywords=<?php echo $_REQUEST[keywords]; ?>">下一页</a></li>
    <?php }

    if ($totalPage>1) { //下一页 ?>
    <li><a href="?page=<?php echo $totalPage; ?>&keywords=<?php echo $_REQUEST[keywords]; ?>">尾页</a></li>

    <?php }?>


  </ul>

</div>           
</div>
</form>
</body>
<script type="text/javascript">
  function add(){
    window.location.href="addad.php";
  }
  $('.onS').on({
    click: function(){
      $('.onS').removeClass("sub_nav_active");
      $(this).addClass("sub_nav_active");
    },
  });
</script>
</html>
